SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspCity_UPDATE
(
@id int = null,
@countryId int = null,
@regionId int = null,
@name nvarchar(128) = null,
@isVisible bit = null
)
AS

UPDATE
  [dbo].[City]
SET
  [Id] = @id,
  [CountryId] = @countryId,
  [RegionId] = @regionId,
  [Name] = @name,
  [IsVisible] = @isVisible
WHERE
  [Id] = @id

GO
